/*
 Navicat Premium Data Transfer

 Source Server         : 腾讯 - 上海主
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : sh-cynosdbmysql-grp-mt4yx9ow.sql.tencentcdb.com:25191
 Source Schema         : crm.zxnnn.cn

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 07/10/2022 14:07:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hq_admin
-- ----------------------------
DROP TABLE IF EXISTS `hq_admin`;
CREATE TABLE `hq_admin` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int(5) DEFAULT NULL COMMENT ' 部门ID',
  `roles` varchar(100) DEFAULT NULL COMMENT '角色',
  `username` varchar(100) DEFAULT NULL COMMENT '用户名',
  `mobile` char(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '手机',
  `password` varchar(32) DEFAULT NULL COMMENT '密码',
  `name` varchar(255) DEFAULT NULL COMMENT '姓名',
  `avatarurl` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '头像',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0禁用/1启动',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间',
  `last_login_ip` varchar(16) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '上次登录IP',
  `login_count` int(11) NOT NULL DEFAULT '0' COMMENT '登录次数',
  `sort_order` smallint(5) DEFAULT '0' COMMENT '排序',
  `remark` varchar(255) DEFAULT NULL COMMENT ' 备注信息',
  `birthday` int(10) DEFAULT NULL COMMENT '生日',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='管理员 用户表';

-- ----------------------------
-- Records of hq_admin
-- ----------------------------
BEGIN;
INSERT INTO `hq_admin` VALUES (1, 0, '1', 'admin', '13459401111', 'e10adc3949ba59abbe56e057f20f883e', '黄青', 'http://limao.ennn.cn/uploads/admin/20220426/3c1743f1d1cdc26713b09fd5a7cbed6b.png', 1, 1665122406, '120.231.208.191', 185, 0, '这是老板', 1651161600, 1631083185, 1658152559, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `hq_admin_menu`;
CREATE TABLE `hq_admin_menu` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(11) unsigned NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `icon` varchar(64) NOT NULL DEFAULT '',
  `path` varchar(255) NOT NULL DEFAULT '',
  `component` varchar(255) DEFAULT NULL,
  `hide` tinyint(5) DEFAULT '0' COMMENT '1 不显示  0显示  注册路由,是否显示',
  `menuType` tinyint(5) DEFAULT '0' COMMENT '菜单类型',
  `active` varchar(100) DEFAULT NULL,
  `hideFooter` tinyint(5) DEFAULT '0' COMMENT '0 是否隐藏全局页脚',
  `hideSidebar` tinyint(5) DEFAULT '0' COMMENT '0 是否隐藏侧边栏',
  `closable` tinyint(5) DEFAULT '1' COMMENT '1 是否可以在多页签中关闭',
  `tabUnique` tinyint(5) DEFAULT '1' COMMENT '1 同路由不同参数页签是否只显示一个',
  `target` char(30) DEFAULT '_self',
  `authority` char(30) DEFAULT NULL,
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT '排序',
  `index` tinyint(1) NOT NULL DEFAULT '0' COMMENT '快捷导航',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `color` char(30) DEFAULT NULL,
  `meta` char(255) DEFAULT NULL,
  `checked` char(255) DEFAULT NULL,
  `children` varchar(255) DEFAULT NULL,
  `deleted` int(5) DEFAULT '0',
  `tenantId` int(5) DEFAULT NULL,
  `createTime` int(11) DEFAULT NULL,
  `updateTime` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8 COMMENT='管理员 菜单表';

-- ----------------------------
-- Records of hq_admin_menu
-- ----------------------------
BEGIN;
INSERT INTO `hq_admin_menu` VALUES (1, 0, '控制台', 'AppstoreOutlined', '/home', '', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (3, 1, '控制台', '', '/home/index/index', '/home/index/index', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (8, 0, '系统设置', 'SettingOutlined', '/setting', '', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 9, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (9, 0, '管理员管理', 'UserOutlined', '/admin', '', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 10, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (10, 9, '管理员列表', '', '/admin/user/index', '/admin/user/index', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (11, 9, '角色管理', '', '/admin/role/index', '/admin/role/index', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (12, 9, '菜单管理', '', '/admin/menu/index', '/admin/menu/index', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 10, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (13, 8, '基本信息', '', '/setting/website', '/setting/website', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (14, 8, '参数配置', '', '/setting/system', NULL, 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (15, 14, '存储配置', '', '/setting/system/storage', '/setting/system/storage', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (16, 14, '公众号配置', '', '/setting/system/weixin', '/setting/system/weixin', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (17, 14, '小程序配置', '', '/setting/system/wxapp', '/setting/system/wxapp', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (18, 14, '微信支付', '', '/setting/system/wxpay', '/setting/system/wxpay', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (19, 14, '短信配置', '', '/setting/system/sms', '/setting/system/sms', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (22, 8, '附件管理', '', '/setting/file', '/setting/file', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (24, 9, '个人中心', '', '/admin/user/userinfo', '/admin/user/userinfo', 1, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (27, 8, '字典管理', '', '/setting/dict/index', '/setting/dict/index', 0, 0, NULL, 0, 0, 1, 1, '_self', NULL, 0, 0, 1, NULL, NULL, NULL, NULL, 0, 2, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (102, 0, '客户管理', 'OneToOneOutlined', '/customer', '', 0, 0, NULL, 0, 0, 1, 1, '_self', '', 0, 0, 1, NULL, '', NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (103, 102, '客户列表', '', '/customer/index/index', '/customer/index/index', 0, 0, NULL, 0, 0, 1, 1, '_self', '', 0, 0, 1, NULL, '', NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (107, 102, '客户详情', '', '/customer/detail/index', '/customer/detail/index', 1, 0, NULL, 0, 0, 1, 1, '_self', '', 0, 0, 1, NULL, '', NULL, NULL, 0, NULL, NULL, NULL);
INSERT INTO `hq_admin_menu` VALUES (108, 102, '合同列表', '', '/customer/hetong/index', '/customer/hetong/index', 0, 0, NULL, 0, 0, 1, 1, '_self', '', 0, 0, 1, NULL, '', NULL, NULL, 0, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for hq_admin_role
-- ----------------------------
DROP TABLE IF EXISTS `hq_admin_role`;
CREATE TABLE `hq_admin_role` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '' COMMENT '角色名称',
  `code` char(30) DEFAULT NULL COMMENT '角色标识',
  `description` varchar(255) NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `roles` text NOT NULL,
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='管理员 用户角色表';

-- ----------------------------
-- Records of hq_admin_role
-- ----------------------------
BEGIN;
INSERT INTO `hq_admin_role` VALUES (1, '超级管理员', NULL, '超级管理员的', 1, '1,3,8,13,14,15,16,17,18,19,22,27,9,10,11,12,24,102,103,107,108', 1634987333, 1665067722, 0);
INSERT INTO `hq_admin_role` VALUES (2, '管理員', '管理員', '', 1, '1,3,102,103,106', 1662965001, 1662981617, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_customer
-- ----------------------------
DROP TABLE IF EXISTS `hq_customer`;
CREATE TABLE `hq_customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) DEFAULT NULL COMMENT '客户名称',
  `level_id` int(5) DEFAULT NULL COMMENT '客户级别',
  `from_id` int(5) DEFAULT NULL COMMENT '客户来源',
  `trade_id` int(5) DEFAULT NULL COMMENT '行业',
  `contact` varchar(100) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(100) DEFAULT NULL COMMENT '联系手机',
  `province` varchar(100) DEFAULT NULL COMMENT '省',
  `city` varchar(100) DEFAULT NULL COMMENT '市',
  `region` varchar(100) DEFAULT NULL COMMENT '区',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `latitude` varchar(100) DEFAULT NULL COMMENT '坐标LAT',
  `longitude` varchar(100) DEFAULT NULL COMMENT '坐标LNG',
  `web` varchar(100) DEFAULT NULL COMMENT '网址',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `status` int(5) DEFAULT '0' COMMENT '状态',
  `status_name` tinyint(1) DEFAULT NULL COMMENT '状态名称',
  `kefu_id` int(5) DEFAULT '0' COMMENT '客服ID',
  `user_id` int(5) DEFAULT '0' COMMENT '创建用户',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='客户信息表';

-- ----------------------------
-- Records of hq_customer
-- ----------------------------
BEGIN;
INSERT INTO `hq_customer` VALUES (3, '中盛联和', 10055, 10052, 10054, NULL, '18611680097', '福建省', '福州市', '晋安区', '宦溪街129号', '26.18455', '119.371126', '', '的订单', 10, NULL, 320, 320, 1659158331, 1664928895, 1664928895);
INSERT INTO `hq_customer` VALUES (4, 'QwQ', 10056, NULL, NULL, NULL, '13812345678', '北京市', '', '东城区', '正义路与东交民巷交叉口西北120米', '39.903289', '116.406013', '', '', 10, NULL, 320, 320, 1659343367, 1664928895, 1664928895);
INSERT INTO `hq_customer` VALUES (5, 'sdsd', 10056, 10052, 10028, NULL, NULL, '110000', '110100', '110101', 'sdsad', NULL, NULL, 'sdsd', '', 10, NULL, 321, 320, 1664773255, 1664928895, 1664928895);
INSERT INTO `hq_customer` VALUES (10, 'safd', 10055, 10026, 10027, '12', '13800138000', '北京市', '', '东城区', '正义路与东交民巷交叉口西北120米', '39.903289', '116.406013', '', '', 10, NULL, 3, 1, 1664928984, 1665068707, 0);
INSERT INTO `hq_customer` VALUES (11, '11111', NULL, 10026, 10028, '黄青', '13455555555', '140000', '140400', '140424', '2222', NULL, NULL, NULL, '12121', 0, NULL, 1, 1, 1665064552, 1665065421, 0);
INSERT INTO `hq_customer` VALUES (12, '目雪科技', NULL, 0, 0, '黄', '13888888888', NULL, NULL, NULL, '', NULL, NULL, NULL, '', 0, NULL, 0, 1, 1665122346, 1665122346, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_customer_hetong
-- ----------------------------
DROP TABLE IF EXISTS `hq_customer_hetong`;
CREATE TABLE `hq_customer_hetong` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `customer_id` int(5) DEFAULT NULL COMMENT '客户ID',
  `type_id` int(5) DEFAULT NULL COMMENT '合同类型',
  `sn` varchar(100) DEFAULT NULL COMMENT '合同编号',
  `name` varchar(100) DEFAULT NULL COMMENT '合同名称',
  `price` decimal(10,2) DEFAULT NULL COMMENT '合同总价',
  `start_time` int(11) DEFAULT NULL COMMENT '合同开始日期',
  `end_time` int(11) DEFAULT NULL COMMENT '合同结束日期',
  `remark` varchar(500) DEFAULT NULL COMMENT '合同备注',
  `file` varchar(255) DEFAULT NULL COMMENT '合同附件',
  `user_id` int(5) DEFAULT NULL COMMENT '创建人',
  `status` tinyint(5) DEFAULT '0' COMMENT '状态 0',
  `exp_day` tinyint(5) DEFAULT '0' COMMENT '剩余天数',
  `is_renew` tinyint(5) DEFAULT '0' COMMENT '是否续期',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='合同';

-- ----------------------------
-- Records of hq_customer_hetong
-- ----------------------------
BEGIN;
INSERT INTO `hq_customer_hetong` VALUES (1, 11, 10032, '2332', '111', 222.00, 1664380800, 1665590400, '223', NULL, 1, 0, NULL, 1, 1665067322, 1665067599, 0);
INSERT INTO `hq_customer_hetong` VALUES (2, 11, 10031, 'dfgdfd', 'rytd', 444.00, 1664208000, 1665504000, '3', NULL, 1, 1, NULL, -1, 1665068444, 1665068444, 0);
INSERT INTO `hq_customer_hetong` VALUES (3, 10, 10023, '23', '23', 22.00, 1665590400, 1668268800, 'sdfasdf', NULL, 1, 1, NULL, -1, 1665068722, 1665113985, 0);
INSERT INTO `hq_customer_hetong` VALUES (4, 11, 10020, '20221007', '小程序商城', 9000.00, 1664553600, 1696003200, '', NULL, 1, 0, 0, -1, 1665117188, 1665117188, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_customer_info
-- ----------------------------
DROP TABLE IF EXISTS `hq_customer_info`;
CREATE TABLE `hq_customer_info` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `customer_id` int(5) DEFAULT NULL COMMENT '客户ID',
  `type_id` int(5) DEFAULT NULL COMMENT '类型',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `infos` varchar(500) DEFAULT NULL COMMENT '内容',
  `is_secrecy` tinyint(5) DEFAULT '0' COMMENT '是否保密',
  `files` varchar(2000) DEFAULT NULL COMMENT '文件附件',
  `user_id` int(5) DEFAULT NULL COMMENT '账号',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  `update_time` int(11) DEFAULT NULL COMMENT '更新时间',
  `delete_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of hq_customer_info
-- ----------------------------
BEGIN;
INSERT INTO `hq_customer_info` VALUES (1, 11, 10024, '2222323', '[{\"title\":\"222\"},{\"title\":\"4444\"},{\"title\":\"545\"},{\"title\":\"6656\"}]', 0, NULL, 1, 1665110702, 1665110702, 0);
INSERT INTO `hq_customer_info` VALUES (2, 11, 10034, '1做', '[{\"title\":\"\\u7533\\u8fbe\\u80a1\\u4efd\\u554a\\u662f\\u6253\\u53d1\\u963f\\u8428\\u5fb7\\u6cd5\\u5e08\\u6253\\u53d1\\u662f\"},{\"title\":\"\\u554a\\u53d1\\u751f\\u7684\\u53d1\\u963f\\u6c34\\u6253\\u53d1\\u662f\\u6253\\u53d1\\u963f\\u8428\\u6cd5\"},{\"title\":\"\\u554a\\u90fd\\u662f\\u53d1\\u6c99\\u53d1\\u662f\\u6253\\u53d1\\u554a\\u662f\\u6253\\u53d1\\u554a\\u662f\\u6253\\u53d1\"}]', 0, NULL, 1, 1665110827, 1665111109, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_customer_price
-- ----------------------------
DROP TABLE IF EXISTS `hq_customer_price`;
CREATE TABLE `hq_customer_price` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  `customer_id` int(5) DEFAULT NULL COMMENT '客户id',
  `hetong_id` int(5) DEFAULT NULL COMMENT '合同ID',
  `datetime` int(11) DEFAULT NULL COMMENT '付款时间',
  `type_id` int(5) DEFAULT NULL COMMENT '付款类型',
  `price` decimal(10,2) DEFAULT NULL COMMENT '本次回款金额',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `user_id` int(5) DEFAULT NULL COMMENT '用户',
  `files` varchar(2000) DEFAULT NULL COMMENT '附件',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `update_time` int(11) DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(11) DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hq_customer_price
-- ----------------------------
BEGIN;
INSERT INTO `hq_customer_price` VALUES (1, 11, 1, 1665072000, 10035, 333.00, '阿的说法是', 1, NULL, 1665112940, 1665112992, 0);
INSERT INTO `hq_customer_price` VALUES (2, 11, 4, 1665072000, 10035, 5000.00, NULL, 1, NULL, 1665117324, 1665117324, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_dict
-- ----------------------------
DROP TABLE IF EXISTS `hq_dict`;
CREATE TABLE `hq_dict` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(50) DEFAULT NULL COMMENT '字典类目名称',
  `sort_order` tinyint(5) DEFAULT '10' COMMENT '排序',
  `is_system` tinyint(5) NOT NULL DEFAULT '0' COMMENT '系统 0否 1是',
  `is_level` tinyint(5) DEFAULT '0',
  `is_multiple` tinyint(5) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1009 DEFAULT CHARSET=utf8 COMMENT='字典';

-- ----------------------------
-- Records of hq_dict
-- ----------------------------
BEGIN;
INSERT INTO `hq_dict` VALUES (1001, '客户来源', 10, 0, 0, 0);
INSERT INTO `hq_dict` VALUES (1002, '客户行业', 10, 0, 0, 0);
INSERT INTO `hq_dict` VALUES (1003, '客户级别', 10, 0, 0, 0);
INSERT INTO `hq_dict` VALUES (1004, '合同类型', 10, 0, 0, 0);
INSERT INTO `hq_dict` VALUES (1005, '信息类型', 10, 0, 0, 0);
INSERT INTO `hq_dict` VALUES (1006, '付款类型', 10, 0, 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `hq_dict_data`;
CREATE TABLE `hq_dict_data` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dict_id` int(5) NOT NULL DEFAULT '0' COMMENT '字典ID',
  `pid` int(5) DEFAULT '0' COMMENT '上级ID',
  `name` varchar(100) NOT NULL COMMENT '字典名称',
  `value` varchar(100) DEFAULT NULL COMMENT '字段值',
  `sort_order` tinyint(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `status` tinyint(10) NOT NULL DEFAULT '1' COMMENT '状态 0禁用 1启用',
  `is_system` tinyint(10) NOT NULL DEFAULT '0' COMMENT '系统字段 0否 1是',
  `remark` varchar(255) DEFAULT NULL,
  `is_default` tinyint(5) DEFAULT NULL,
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10037 DEFAULT CHARSET=utf8 COMMENT='字典数据';

-- ----------------------------
-- Records of hq_dict_data
-- ----------------------------
BEGIN;
INSERT INTO `hq_dict_data` VALUES (10008, 1004, 0, '2aaa', '3', 4, 1, 0, '', NULL, 1650886030, 1650887542, 1650887542);
INSERT INTO `hq_dict_data` VALUES (10009, 1004, 0, '2323', '2323', 127, 1, 0, '', NULL, 1650886339, 1650887635, 1650887635);
INSERT INTO `hq_dict_data` VALUES (10010, 1004, 0, '22dsafa', '33', 44, 1, 0, '', NULL, 1650886440, 1650887635, 1650887635);
INSERT INTO `hq_dict_data` VALUES (10011, 1004, 0, '软件定制开发', '', 0, 1, 0, '', NULL, 1650886518, 1665065947, 0);
INSERT INTO `hq_dict_data` VALUES (10020, 1004, 0, '小程序商城', '', 0, 1, 0, '', NULL, 1650887162, 1665065961, 0);
INSERT INTO `hq_dict_data` VALUES (10021, 0, 0, '是打发', '啊是否', 0, 1, 0, '', NULL, 1650888733, 1650888733, 0);
INSERT INTO `hq_dict_data` VALUES (10022, 0, 0, '2', '3', 0, 1, 0, '', NULL, 1650889024, 1650889024, 0);
INSERT INTO `hq_dict_data` VALUES (10023, 1004, 0, '红包营销插件', '', 0, 1, 0, '', NULL, 1650889065, 1665065972, 0);
INSERT INTO `hq_dict_data` VALUES (10024, 1005, 0, '账号信息', '', 0, 1, 0, '', NULL, 1651041538, 1665109878, 0);
INSERT INTO `hq_dict_data` VALUES (10025, 1001, 0, '朋友介绍', '', 0, 1, 0, '', NULL, 1665063295, 1665063295, 0);
INSERT INTO `hq_dict_data` VALUES (10026, 1001, 0, '老客户介绍', '', 0, 1, 0, '', NULL, 1665063301, 1665063301, 0);
INSERT INTO `hq_dict_data` VALUES (10027, 1002, 0, '医美', '', 0, 1, 0, '', NULL, 1665063310, 1665063310, 0);
INSERT INTO `hq_dict_data` VALUES (10028, 1002, 0, '其他', '', 0, 1, 0, '', NULL, 1665063334, 1665063334, 0);
INSERT INTO `hq_dict_data` VALUES (10029, 1003, 0, '有意向', '', 0, 1, 0, '', NULL, 1665063355, 1665063355, 0);
INSERT INTO `hq_dict_data` VALUES (10030, 1003, 0, '无意向', '', 0, 1, 0, '', NULL, 1665063361, 1665063361, 0);
INSERT INTO `hq_dict_data` VALUES (10031, 1004, 0, '网站建设', '', 0, 1, 0, '', NULL, 1665065982, 1665065982, 0);
INSERT INTO `hq_dict_data` VALUES (10032, 1004, 0, '服务器租用', '', 0, 1, 0, '', NULL, 1665065991, 1665065991, 0);
INSERT INTO `hq_dict_data` VALUES (10033, 1004, 0, '其他类型', '', 0, 1, 0, '', NULL, 1665065996, 1665065996, 0);
INSERT INTO `hq_dict_data` VALUES (10034, 1005, 0, '其他信息', '', 0, 1, 0, '', NULL, 1665109893, 1665109893, 0);
INSERT INTO `hq_dict_data` VALUES (10035, 1006, 0, '合同回款', '', 0, 1, 0, '', NULL, 1665112863, 1665112863, 0);
INSERT INTO `hq_dict_data` VALUES (10036, 1006, 0, '其他款项', '', 0, 1, 0, '', NULL, 1665112869, 1665112869, 0);
COMMIT;

-- ----------------------------
-- Table structure for hq_system
-- ----------------------------
DROP TABLE IF EXISTS `hq_system`;
CREATE TABLE `hq_system` (
  `id` int(3) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `key` varchar(100) DEFAULT NULL COMMENT '配置字段',
  `name` varchar(100) DEFAULT NULL COMMENT '配置名称',
  `jdata` text COMMENT '配置参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='系统配置表';

-- ----------------------------
-- Records of hq_system
-- ----------------------------
BEGIN;
INSERT INTO `hq_system` VALUES (1, 'website', '网站配置', '{\"name\":\"\",\"title\":\"12\",\"keyword\":\"1212\",\"description\":\"1212\",\"photo\":[\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/20220426\\/fb5fd97fe8bdc6f02a161c279e82e8e8.jpg\",\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/20220426\\/0b61b593099bf008da3a5d79f7354f9a.PNG\",\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/20220426\\/47deb13170a530fc63e390cf4743cce6.jpeg\",\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/20220426\\/014f74d4c0d1181fec6658f0d67556d9.png\"],\"logo\":\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/20220427\\/519073f98b6b5e6defc4e27eb16e4768.jpg\",\"file\":[\"http:\\/\\/limao.ennn.cn\\/uploads\\/admin\\/\\u56fd\\u9ad8\\u5e74\\u62a5\\u8865\\u5145\\u6570\\u636e.doc\",\"http:\\/\\/limao.ennn.cn\\/uploads\\/202204\\/20220112\\u7f51\\u7ad9\\u4fee\\u6539\\u9879\\u76ee.docx\"]}');
INSERT INTO `hq_system` VALUES (2, 'storage', '七牛配置', '{\"name\":\"\",\"model\":\"storage\",\"type\":\"local\",\"ak\":\"12\",\"sk\":\"23\",\"bucket\":\"34\",\"domain\":\"45\"}');
INSERT INTO `hq_system` VALUES (3, 'weixin', '公众号配置', '{\"name\":\"\",\"model\":\"weixin\",\"appid\":\"wx300a5a9d2a\",\"appsecret\":\"fasdfasf\",\"token\":\"33\",\"aes_key\":\"\",\"type\":\"0\",\"aeskey\":\"44\"}');
INSERT INTO `hq_system` VALUES (4, 'wxapp', '小程序配置', '{\"name\":\"\",\"model\":\"wxapp\",\"appid\":\"123\",\"appsecret\":\"123455\"}');
INSERT INTO `hq_system` VALUES (5, 'wxpay', '微信支付配置', '{\"name\":\"\",\"model\":\"wxpay\",\"appid\":\"\",\"mch_id\":\"\",\"key\":\"\",\"notify_url\":\"\",\"certpem\":\"\",\"keypem\":\"\",\"type\":\"0\"}');
INSERT INTO `hq_system` VALUES (6, 'sms', '腾讯云短信', '{\"name\":\"\",\"appid\":\"1400136510\",\"appsecret\":\"5eee1991d9f4bcfc8f02761d64638448\"}');
INSERT INTO `hq_system` VALUES (10, 'upload_setting', '上传选项', '{\"is_thumb\":\"1\",\"max_width\":\"1500\",\"max_height\":\"1500\"}');
COMMIT;

-- ----------------------------
-- Table structure for hq_uploads
-- ----------------------------
DROP TABLE IF EXISTS `hq_uploads`;
CREATE TABLE `hq_uploads` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `store_id` int(5) DEFAULT '0' COMMENT '商户ID',
  `user_id` int(5) unsigned DEFAULT '0' COMMENT '用户ID',
  `storage` char(10) DEFAULT NULL COMMENT '存储位置',
  `file_url` varchar(100) DEFAULT NULL COMMENT '存储域名',
  `file_key` varchar(100) DEFAULT NULL COMMENT '存储KEY',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `file_size` varchar(100) DEFAULT NULL COMMENT '文件大小',
  `mine` varchar(30) DEFAULT NULL COMMENT '文件类型',
  `status` int(3) DEFAULT '1' COMMENT '状态',
  `create_time` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `delete_time` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10014 DEFAULT CHARSET=utf8 COMMENT='附件表';

-- ----------------------------
-- Records of hq_uploads
-- ----------------------------
BEGIN;
INSERT INTO `hq_uploads` VALUES (10001, 0, 1, 'local', '', 'uploads/admin/20220428/2175a47bbff411fa02562d2862407a19.png', 'basicprofile.png', '5749', 'image/png', 1, 1651123042, 1651123042, 0);
INSERT INTO `hq_uploads` VALUES (10002, 0, 1, 'local', '', 'uploads/admin/20220428/d3c1932246a575325dec9088d8fc051b.png', 'basicprofile.png', '5749', 'image/png', 1, 1651123074, 1651123074, 0);
INSERT INTO `hq_uploads` VALUES (10003, 21, 320, 'local', '', 'uploads/store/20220428/a096f2fb84bbe4a6edd13772e2df705e.jpeg', '4090ccf385f050e83deeac272f8df2efwww790-790.jpeg', '122594', 'image/jpeg', 1, 1651154340, 1651154340, 0);
INSERT INTO `hq_uploads` VALUES (10004, 21, 320, 'local', '', 'uploads/store/20220527/b33a25887186e2c1bad142d3bb4114e5.png', '1111111.png', '28823', 'image/png', 1, 1653650023, 1653650023, 0);
INSERT INTO `hq_uploads` VALUES (10005, 21, 320, 'local', '', 'uploads/store/20220527/998f76b21422b63d767b32f0c540382f.png', '11111111.png', '714809', 'image/png', 1, 1653650482, 1653650482, 0);
INSERT INTO `hq_uploads` VALUES (10006, 21, 320, 'local', '', 'uploads/store/20220527/bba8bb88610d15e97d3a8a5a53d90d35.png', '出纳宝108.png', '3856', 'image/png', 1, 1653653721, 1653653721, 0);
INSERT INTO `hq_uploads` VALUES (10007, 21, 320, 'local', '', 'uploads/store/20220530/21ef7b37223892d1febc8e3bc653654c.png', '11111111.png', '714809', 'image/png', 1, 1653916326, 1653916326, 0);
INSERT INTO `hq_uploads` VALUES (10008, 21, 320, 'local', '', 'uploads/store/20220618/f43488ac3e34637c556c7a0630b0d5b4.jpeg', 'WechatIMG7.jpeg', '42375', 'image/jpeg', 1, 1655564559, 1655564559, 0);
INSERT INTO `hq_uploads` VALUES (10009, 21, 320, 'local', '', 'uploads/store/20220618/862cf0dbd8db8052c4cf29b37c16a012.jpeg', 'WechatIMG8.jpeg', '48830', 'image/jpeg', 1, 1655564615, 1655564615, 0);
INSERT INTO `hq_uploads` VALUES (10010, 21, 320, 'local', '', 'uploads/store/20220618/6e50ae8947f325afdbd1d6b3fc0235f6.jpeg', 'WechatIMG9.jpeg', '31004', 'image/jpeg', 1, 1655564622, 1655564622, 0);
INSERT INTO `hq_uploads` VALUES (10011, 21, 320, 'local', '', 'uploads/store/20220618/791136939977779f3c8baed46d07ea8b.jpeg', 'WechatIMG10.jpeg', '64807', 'image/jpeg', 1, 1655564715, 1655564715, 0);
INSERT INTO `hq_uploads` VALUES (10012, 21, 320, 'local', '', 'uploads/store/20220618/49cae159094a6d543afa5ad81a87244e.jpeg', 'WechatIMG10.jpeg', '64807', 'image/jpeg', 1, 1655565073, 1655565073, 0);
INSERT INTO `hq_uploads` VALUES (10013, 21, 320, 'local', '', 'uploads/store/20220828/6cfd6ade3bc8acc033b003ef45c3a6ba.png', '未命名绘图.png', '37443', 'image/png', 1, 1661677709, 1661677709, 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
